CREATE TABLE cv$_target
(
	id		INTEGER,
	owner	VARCHAR2(32),
	name	VARCHAR2(32),
	map_package_owner	VARCHAR2(32),
	map_package_name	VARCHAR2(32),
	last_refresh_type	VARCHAR2(8),
	last_refresh_date	DATE,
	parent_id INTEGER,
	logical_type VARCHAR2(2),
	is_virtual VARCHAR2(1),
	parent_owner		VARCHAR2(32),
	parent_name			VARCHAR2(32),
	execution_order	INTEGER,
	dependencies		VARCHAR2(4000),
	CONSTRAINT cv$_target_pk PRIMARY KEY (id)
		USING INDEX
		(
			CREATE UNIQUE INDEX cv$_target_pk_idx ON cv$_target(id ASC)
		)
);

CREATE INDEX cv$_target_name_idx ON cv$_target(owner	ASC, name ASC);
